Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_9726

R_9726

CO_DISH

CO_DELIVERYITEM

CO_DISHID

 

 

R_9727

R_9727

CO_DELIVERY

CO_L_DELIVERYORDERITEM

CO_DELIVERYID

 

 

R_9728

R_9728

CO_ORDERITEM

CO_L_DELIVERYORDERITEM

CO_ORDERITEMID

 

 

R_9729

R_9729

CO_DELIVERYSTATUS

CO_DELIVERY

CO_DELIVERYSTATUSID

 

 

R_9731

R_9731

CO_DELIVERY

CO_L_DELIVERYMEAL

CO_DELIVERYID

 

 

R_9822

R_9822

CO_PRODUCTIONSTATUS

CO_PRODUCTION

PRODUCTIONSTATUSID

 

 

R_9823

R_9823

CO_DICTKITCHEN

CO_PRODUCTION

KITCHENID

 

 

R_9824

R_9824

CO_DICTPRODUCT

CO_PRODUCTIONINGREDIENT

PRODUCTID

 

 

R_9825

R_9825

CO_DICTUNIT

CO_PRODUCTIONINGREDIENT

UNITID

 

 

R_9826

R_9826

CO_DISH

CO_PRODUCTIONPRODUCT

DISHID

 

 

R_9827

R_9827

CO_PRODUCTIONSTATUS

CO_PRODUCTIONSTATUSTEXT

PRODUCTIONSTATUSID

 

 

R_9828

R_9828

CO_PRODUCTION

CO_L_PRODUCTIONORDER

PRODUCTIONID

 

 

R_9829

R_9829

CO_ORDER

CO_L_PRODUCTIONORDER

ORDERID

 

 

R_9830

R_9830

CO_PRODUCTION

CO_L_PRODUCTIONORDERITEM

PRODUCTIONID

 

 

R_9831

R_9831

CO_ORDERITEM

CO_L_PRODUCTIONORDERITEM

ORDERITEMID

 

 

R_9868

R_9868

CO_DICTKITCHEN

Co_L_OrgUnitDictKitchen

Co_DictKitchenID

 

 

R_9869

R_9869

CO_DictUnitType

CO_DictUnitTypeText

CO_DictUnitTypeId

 

 

R_9870

R_9870

CO_DICTUNIT

Co_DictUnitText

Co_DictUnitId

 

 

R_9871

R_9871

CO_DictUnitType

CO_DICTUNIT

CO_DictUnitTypeId

 

 

R_9875

R_9875

Person

Co_Registration

PatientId

 

 

R_9877

R_9877

Co_Registration

Co_L_RegistrationOrderItem

Co_RegistrationId

 

 

R_9878

R_9878

CO_ORDERITEM

Co_L_RegistrationOrderItem

Co_OrderItemId

 

 

R_9879

R_9879

CO_DICTKITCHEN

CO_DICTMEALORDERDAY

Co_DictKitchenId

 

 

R_9880

R_9880

PhLot

Co_L_OrderItemProduction

LotId

 

 

R_9881

R_9881

CO_ORDERITEM

Co_L_OrderItemProduction

Co_OrderItemId

 

 

R_9882

R_9882

CO_PRODUCTION

Co_L_OrderItemProduction

Co_ProductionId

 

 

R_9883

R_9883

CO_DELIVERYITEM

Co_L_DeliveryItemOrderItem

Co_DeliveryItemId

 

 

R_9884

R_9884

CO_ORDERITEM

Co_L_DeliveryItemOrderItem

OrderItemId

 

 

R_9944

R_9944

Co_OrderType

Co_OrderTypeText

OrderTypeId

 

 

R_9945

R_9945

Co_OrderType

CO_ORDER

OrderTypeId

 

 

R_9947

R_9947

CO_PRODUCTION

Co_ProductionPortion

ProductionId

 

 

R_9948

R_9948

CO_DICTUNIT

Co_ProductionPortion

UnitID

 

 

R_9950

R_9950

CO_PRODUCTION

CO_PRODUCTIONINGREDIENT

PRODUCTIONID

 

 

R_9998

R_9998

Allergen

AllergenText

AllergenID

 

 

R_9999

R_9999

CO_RECIPE

Co_RecipeAllergen

RecipeID

 

 

R_10000

R_10000

Allergen

Co_RecipeAllergen

AllergenID

 

 

R_10002

R_10002

AllergenType

AllergenTypeText

AllergenTypeId

 

 

R_10003

R_10003

AllergenType

Allergen

AllergenTypeId

 

 

R_10025

R_10025

CO_ORDERITEM

Co_LOrderItemOrgUnit

OrderItemID

 

 

R_10026

R_10026

CO_DELIVERY

Co_LDeliveryStDoc

DeliveryID

 

 

R_10027

R_10027

CO_DELIVERYITEM

Co_LDeliveryItemOrgUnit

DeliveryItemID

 

 

R_10050

R_10050

Co_ProductGroup

Co_ProductGroupText

ProductGroupId

 

 

R_10051

R_10051

CO_DICTPRODUCT

Co_ProductProductGroup

ProductId

 

 

R_10052

R_10052

Co_ProductGroup

Co_ProductProductGroup

ProductGroupId

 

 


1  2